| Number of Variables | 6 |
|---|---|
| Number of Rows | 99441 |
| Missing Cells | 0 |
| Missing Cells (%) | 0.0% |
| Duplicate Rows | 0 |
| Duplicate Rows (%) | 0.0% |
| Total Size in Memory | 30.4 MB |
| Average Row Size in Memory | 320.3 B |
| Variable Types |
|
| index is uniformly distributed | Uniform |
|---|---|
| customer_id has a high cardinality: 99441 distinct values | High Cardinality |
| customer_unique_id has a high cardinality: 96096 distinct values | High Cardinality |
| customer_city has a high cardinality: 4119 distinct values | High Cardinality |
| customer_id has constant length 32 | Constant Length |
| customer_unique_id has constant length 32 | Constant Length |
| customer_state has constant length 2 | Constant Length |
| customer_id has all distinct values | Unique |
numerical
| Approximate Distinct Count | 99441 |
|---|---|
| Approximate Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1591056 |
| Mean | 49720 |
| Minimum | 0 |
| Maximum | 99440 |
| Zeros | 1 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 4972 |
| Q1 | 24860 |
| Median | 49720 |
| Q3 | 74580 |
| 95-th Percentile | 94468 |
| Maximum | 99440 |
| Range | 99440 |
| IQR | 49720 |
| Mean | 49720 |
|---|---|
| Standard Deviation | 28706.2884 |
| Variance | 8.2405e+08 |
| Sum | 4.9442e+09 |
| Skewness | 0 |
| Kurtosis | -1.2 |
| Coefficient of Variation | 0.5774 |
categorical
| Approximate Distinct Count | 99441 |
|---|---|
| Approximate Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 9645777 |
| Mean | 32 |
|---|---|
| Standard Deviation | 0 |
| Median | 32 |
| Minimum | 32 |
| Maximum | 32 |
| 1st row | 06b8999e2fba1a1fbc... |
|---|---|
| 2nd row | 18955e83d337fd6b2d... |
| 3rd row | 4e7b3e00288586ebd0... |
| 4th row | b2b6027bc5c5109e52... |
| 5th row | 4f2d8ab171c80ec836... |
| Count | 1193579 |
|---|---|
| Lowercase Letter | 1193579 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 1988533 |
categorical
| Approximate Distinct Count | 96096 |
|---|---|
| Approximate Unique (%) | 96.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 9645777 |
| Mean | 32 |
|---|---|
| Standard Deviation | 0 |
| Median | 32 |
| Minimum | 32 |
| Maximum | 32 |
| 1st row | 861eff4711a542e4b9... |
|---|---|
| 2nd row | 290c77bc529b7ac935... |
| 3rd row | 060e732b5b29e8181a... |
| 4th row | 259dac757896d24d77... |
| 5th row | 345ecd01c38d18a903... |
| Count | 1193030 |
|---|---|
| Lowercase Letter | 1193030 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 1989082 |
numerical
| Approximate Distinct Count | 14994 |
|---|---|
| Approximate Unique (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1591056 |
| Mean | 35137.4746 |
| Minimum | 1003 |
| Maximum | 99990 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1003 |
|---|---|
| 5-th Percentile | 3315 |
| Q1 | 11347 |
| Median | 24416 |
| Q3 | 58900 |
| 95-th Percentile | 90550 |
| Maximum | 99990 |
| Range | 98987 |
| IQR | 47553 |
| Mean | 35137.4746 |
|---|---|
| Standard Deviation | 29797.939 |
| Variance | 8.8792e+08 |
| Sum | 3.4941e+09 |
| Skewness | 0.779 |
| Kurtosis | -0.7882 |
| Coefficient of Variation | 0.848 |
categorical
| Approximate Distinct Count | 4119 |
|---|---|
| Approximate Unique (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 7492329 |
| Mean | 10.3445 |
|---|---|
| Standard Deviation | 3.9946 |
| Median | 9 |
| Minimum | 3 |
| Maximum | 32 |
| 1st row | franca |
|---|---|
| 2nd row | sao bernardo do ca... |
| 3rd row | sao paulo |
| 4th row | mogi das cruzes |
| 5th row | campinas |
| Count | 953332 |
|---|---|
| Lowercase Letter | 953332 |
| Space Separator | 74872 |
| Uppercase Letter | 0 |
| Dash Punctuation | 232 |
| Decimal Number | 2 |
categorical
| Approximate Distinct Count | 27 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 6662547 |
| Mean | 2 |
|---|---|
| Standard Deviation | 0 |
| Median | 2 |
| Minimum | 2 |
| Maximum | 2 |
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
| Count | 198882 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 198882 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |